package com.sky.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;
import java.util.List;

@Mapper
public interface WorkSpaceMapper {

    Double getTotalMoney(LocalDateTime start,LocalDateTime end);

    Integer getActiveOrdersNumber(LocalDateTime start,LocalDateTime end);





    @Select("select count(*) from setmeal where status = #{status} ")
    Integer count(Integer status);

    @Select("select count(*) from dish where status = #{status}")
    Integer countDishStatus(Integer status);


    Integer getOverviewOrders( Integer status);

    @Select("select count(*) from orders")
    Integer selectAllOrdersCount();



}
